Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 418 |
| Missing cells | 826 |
| Missing cells (%) | 12.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 52.4 KiB |
| Average record size in memory | 128.3 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 1 |
df_index is highly correlated with Unnamed: 0 | High correlation |
Unnamed: 0 is highly correlated with df_index | High correlation |
Friday has 30 (7.2%) missing values | Missing |
Monday has 59 (14.1%) missing values | Missing |
Saturday has 96 (23.0%) missing values | Missing |
Sunday has 162 (38.8%) missing values | Missing |
Thursday has 112 (26.8%) missing values | Missing |
Tuesday has 11 (2.6%) missing values | Missing |
Wednesday has 85 (20.3%) missing values | Missing |
ncoachingid has 106 (25.4%) missing values | Missing |
total coaching improved has 162 (38.8%) missing values | Missing |
df_index has unique values | Unique |
Unnamed: 0 has unique values | Unique |
Reproduction
| Analysis started | 2021-05-13 18:56:02.490545 |
|---|---|
| Analysis finished | 2021-05-13 18:56:45.360257 |
| Duration | 42.87 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 418 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 248.4641148 |
|---|---|
| Minimum | 3 |
| Maximum | 488 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 29.85 |
| Q1 | 125.25 |
| median | 250 |
| Q3 | 374.75 |
| 95-th percentile | 465.15 |
| Maximum | 488 |
| Range | 485 |
| Interquartile range (IQR) | 249.5 |
Descriptive statistics
| Standard deviation | 141.3334405 |
|---|---|
| Coefficient of variation (CV) | 0.5688283822 |
| Kurtosis | -1.236389434 |
| Mean | 248.4641148 |
| Median Absolute Deviation (MAD) | 125 |
| Skewness | -0.01755172389 |
| Sum | 103858 |
| Variance | 19975.1414 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 3 | 1 | 0.2% |
| 375 | 1 | 0.2% |
| 338 | 1 | 0.2% |
| 337 | 1 | 0.2% |
| 336 | 1 | 0.2% |
| 335 | 1 | 0.2% |
| 334 | 1 | 0.2% |
| 333 | 1 | 0.2% |
| 332 | 1 | 0.2% |
| 331 | 1 | 0.2% |
| Other values (408) | 408 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 4 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 488 | 1 | |
| 487 | 1 | |
| 486 | 1 | |
| 485 | 1 | |
| 484 | 1 |
| Distinct | 418 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 248.4641148 |
|---|---|
| Minimum | 3 |
| Maximum | 488 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 29.85 |
| Q1 | 125.25 |
| median | 250 |
| Q3 | 374.75 |
| 95-th percentile | 465.15 |
| Maximum | 488 |
| Range | 485 |
| Interquartile range (IQR) | 249.5 |
Descriptive statistics
| Standard deviation | 141.3334405 |
|---|---|
| Coefficient of variation (CV) | 0.5688283822 |
| Kurtosis | -1.236389434 |
| Mean | 248.4641148 |
| Median Absolute Deviation (MAD) | 125 |
| Skewness | -0.01755172389 |
| Sum | 103858 |
| Variance | 19975.1414 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 3 | 1 | 0.2% |
| 375 | 1 | 0.2% |
| 338 | 1 | 0.2% |
| 337 | 1 | 0.2% |
| 336 | 1 | 0.2% |
| 335 | 1 | 0.2% |
| 334 | 1 | 0.2% |
| 333 | 1 | 0.2% |
| 332 | 1 | 0.2% |
| 331 | 1 | 0.2% |
| Other values (408) | 408 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 4 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 488 | 1 | |
| 487 | 1 | |
| 486 | 1 | |
| 485 | 1 | |
| 484 | 1 |
employeeid
Real number (ℝ≥0)
| Distinct | 273 |
|---|---|
| Distinct (%) | 65.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26768058.64 |
|---|---|
| Minimum | 26702507 |
| Maximum | 35706317 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 26702507 |
|---|---|
| 5-th percentile | 26702701.15 |
| Q1 | 26703200.75 |
| median | 26703526 |
| Q3 | 26703807 |
| 95-th percentile | 26703958.45 |
| Maximum | 35706317 |
| Range | 9003810 |
| Interquartile range (IQR) | 606.25 |
Descriptive statistics
| Standard deviation | 760868.2483 |
|---|---|
| Coefficient of variation (CV) | 0.02842448377 |
| Kurtosis | 135.9758747 |
| Mean | 26768058.64 |
| Median Absolute Deviation (MAD) | 294.5 |
| Skewness | 11.71858564 |
| Sum | 1.118904851 × 1010 |
| Variance | 5.789204912 × 1011 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) |
| 26703700 | 3 | 0.7% |
| 26703220 | 3 | 0.7% |
| 26703302 | 3 | 0.7% |
| 26703897 | 3 | 0.7% |
| 26703818 | 3 | 0.7% |
| 26703315 | 3 | 0.7% |
| 26703378 | 3 | 0.7% |
| 26703308 | 3 | 0.7% |
| 26703194 | 3 | 0.7% |
| 26703553 | 3 | 0.7% |
| Other values (263) | 388 |
| Value | Count | Frequency (%) |
| 26702507 | 2 | |
| 26702537 | 2 | |
| 26702549 | 2 | |
| 26702594 | 1 | |
| 26702611 | 1 |
| Value | Count | Frequency (%) |
| 35706317 | 2 | |
| 35706305 | 1 | |
| 26703983 | 1 | |
| 26703982 | 2 | |
| 26703979 | 1 |
| Distinct | 139 |
|---|---|
| Distinct (%) | 35.8% |
| Missing | 30 |
| Missing (%) | 7.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.26657223 |
|---|---|
| Minimum | 67.8575 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 67.8575 |
|---|---|
| 5-th percentile | 83.33375 |
| Q1 | 93.334 |
| median | 96.186 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 32.1425 |
| Interquartile range (IQR) | 6.666 |
Descriptive statistics
| Standard deviation | 5.3706653 |
|---|---|
| Coefficient of variation (CV) | 0.05637512902 |
| Kurtosis | 4.677514818 |
| Mean | 95.26657223 |
| Median Absolute Deviation (MAD) | 3.814 |
| Skewness | -1.862301056 |
| Sum | 36963.43002 |
| Variance | 28.84404577 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 120 | |
| 93.75 | 7 | 1.7% |
| 93.334 | 6 | 1.4% |
| 95 | 6 | 1.4% |
| 90 | 5 | 1.2% |
| 95.83333333 | 5 | 1.2% |
| 95.23857143 | 5 | 1.2% |
| 98.4375 | 4 | 1.0% |
| 94.445 | 4 | 1.0% |
| 87.5 | 4 | 1.0% |
| Other values (129) | 222 | |
| (Missing) | 30 | 7.2% |
| Value | Count | Frequency (%) |
| 67.8575 | 2 | |
| 75 | 2 | |
| 77.78 | 1 | 0.2% |
| 78.334 | 3 | |
| 79.11375 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 100 | 120 | |
| 99.03875 | 2 | 0.5% |
| 98.86375 | 1 | 0.2% |
| 98.71833333 | 3 | 0.7% |
| 98.61125 | 2 | 0.5% |
| Distinct | 139 |
|---|---|
| Distinct (%) | 38.7% |
| Missing | 59 |
| Missing (%) | 14.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.40371216 |
|---|---|
| Minimum | 70.8325 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 70.8325 |
|---|---|
| 5-th percentile | 83.334875 |
| Q1 | 91.66666667 |
| median | 95.3125 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 29.1675 |
| Interquartile range (IQR) | 8.333333333 |
Descriptive statistics
| Standard deviation | 5.534483123 |
|---|---|
| Coefficient of variation (CV) | 0.0586256938 |
| Kurtosis | 1.984383172 |
| Mean | 94.40371216 |
| Median Absolute Deviation (MAD) | 3.64625 |
| Skewness | -1.286373458 |
| Sum | 33890.93267 |
| Variance | 30.63050344 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 92 | |
| 96.29666667 | 8 | 1.9% |
| 87.5 | 7 | 1.7% |
| 96.4275 | 5 | 1.2% |
| 94.44333333 | 5 | 1.2% |
| 95 | 5 | 1.2% |
| 91.66666667 | 5 | 1.2% |
| 90.27833333 | 4 | 1.0% |
| 93.33333333 | 4 | 1.0% |
| 98.14777778 | 4 | 1.0% |
| Other values (129) | 220 | |
| (Missing) | 59 | 14.1% |
| Value | Count | Frequency (%) |
| 70.8325 | 1 | |
| 73.01333333 | 2 | |
| 75 | 2 | |
| 78.476 | 1 | |
| 80 | 1 |
| Value | Count | Frequency (%) |
| 100 | 92 | |
| 98.95875 | 2 | 0.5% |
| 98.76555556 | 2 | 0.5% |
| 98.75 | 2 | 0.5% |
| 98.61125 | 1 | 0.2% |
| Distinct | 109 |
|---|---|
| Distinct (%) | 33.9% |
| Missing | 96 |
| Missing (%) | 23.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.45384609 |
|---|---|
| Minimum | 77.77666667 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 77.77666667 |
|---|---|
| 5-th percentile | 86.174225 |
| Q1 | 92.62825893 |
| median | 96.295 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 22.22333333 |
| Interquartile range (IQR) | 7.371741071 |
Descriptive statistics
| Standard deviation | 4.429498899 |
|---|---|
| Coefficient of variation (CV) | 0.04640461418 |
| Kurtosis | 1.164433239 |
| Mean | 95.45384609 |
| Median Absolute Deviation (MAD) | 3.705 |
| Skewness | -1.086387768 |
| Sum | 30736.13844 |
| Variance | 19.6204605 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 93 | |
| 91.66666667 | 7 | 1.7% |
| 97.91666667 | 6 | 1.4% |
| 91.6675 | 6 | 1.4% |
| 96.4275 | 5 | 1.2% |
| 92.5 | 5 | 1.2% |
| 92.85714286 | 4 | 1.0% |
| 95 | 4 | 1.0% |
| 93.75 | 4 | 1.0% |
| 98.21428571 | 4 | 1.0% |
| Other values (99) | 184 | |
| (Missing) | 96 |
| Value | Count | Frequency (%) |
| 77.77666667 | 2 | |
| 81.99375 | 2 | |
| 83.335 | 1 | |
| 84.62 | 2 | |
| 84.72166667 | 2 |
| Value | Count | Frequency (%) |
| 100 | 93 | |
| 99.04714286 | 1 | 0.2% |
| 98.75 | 2 | 0.5% |
| 98.57142857 | 2 | 0.5% |
| 98.462 | 1 | 0.2% |
| Distinct | 92 |
|---|---|
| Distinct (%) | 35.9% |
| Missing | 162 |
| Missing (%) | 38.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.73439318 |
|---|---|
| Minimum | 50 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 85.71 |
| Q1 | 92.466 |
| median | 95.989375 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 50 |
| Interquartile range (IQR) | 7.534 |
Descriptive statistics
| Standard deviation | 6.077321404 |
|---|---|
| Coefficient of variation (CV) | 0.064151162 |
| Kurtosis | 14.79243065 |
| Mean | 94.73439318 |
| Median Absolute Deviation (MAD) | 3.818 |
| Skewness | -2.983538347 |
| Sum | 24252.00465 |
| Variance | 36.93383545 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 65 | |
| 96.42857143 | 11 | 2.6% |
| 91.665 | 5 | 1.2% |
| 98.41285714 | 5 | 1.2% |
| 93.75 | 4 | 1.0% |
| 92.5 | 4 | 1.0% |
| 97.5 | 4 | 1.0% |
| 95 | 4 | 1.0% |
| 75 | 4 | 1.0% |
| 95.57714286 | 3 | 0.7% |
| Other values (82) | 147 | |
| (Missing) | 162 |
| Value | Count | Frequency (%) |
| 50 | 1 | 0.2% |
| 66.67 | 2 | |
| 75 | 4 | |
| 80 | 1 | 0.2% |
| 83.33333333 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 100 | 65 | |
| 98.70142857 | 3 | 0.7% |
| 98.61125 | 2 | 0.5% |
| 98.57142857 | 2 | 0.5% |
| 98.41285714 | 5 | 1.2% |
| Distinct | 138 |
|---|---|
| Distinct (%) | 45.1% |
| Missing | 112 |
| Missing (%) | 26.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.22196663 |
|---|---|
| Minimum | 57.5 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 57.5 |
|---|---|
| 5-th percentile | 82.17229167 |
| Q1 | 91.666875 |
| median | 95.758375 |
| Q3 | 98.41145833 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 42.5 |
| Interquartile range (IQR) | 6.744583333 |
Descriptive statistics
| Standard deviation | 5.895095966 |
|---|---|
| Coefficient of variation (CV) | 0.06256604672 |
| Kurtosis | 5.525973135 |
| Mean | 94.22196663 |
| Median Absolute Deviation (MAD) | 3.827819444 |
| Skewness | -1.8286406 |
| Sum | 28831.92179 |
| Variance | 34.75215645 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 73 | 17.5% |
| 95 | 7 | 1.7% |
| 94.445 | 6 | 1.4% |
| 95.83375 | 5 | 1.2% |
| 96.666 | 5 | 1.2% |
| 91.665 | 4 | 1.0% |
| 91.66666667 | 4 | 1.0% |
| 96.875 | 4 | 1.0% |
| 90 | 4 | 1.0% |
| 93.75 | 4 | 1.0% |
| Other values (128) | 190 | |
| (Missing) | 112 |
| Value | Count | Frequency (%) |
| 57.5 | 1 | |
| 74.182 | 1 | |
| 75 | 2 | |
| 76.666 | 2 | |
| 77.77666667 | 1 |
| Value | Count | Frequency (%) |
| 100 | 73 | |
| 98.76555556 | 2 | 0.5% |
| 98.485 | 1 | 0.2% |
| 98.4375 | 1 | 0.2% |
| 98.33333333 | 1 | 0.2% |
| Distinct | 166 |
|---|---|
| Distinct (%) | 40.8% |
| Missing | 11 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.19500538 |
|---|---|
| Minimum | 61.666 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 61.666 |
|---|---|
| 5-th percentile | 86.91156944 |
| Q1 | 93.44666667 |
| median | 96.01 |
| Q3 | 98.4375 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 38.334 |
| Interquartile range (IQR) | 4.990833333 |
Descriptive statistics
| Standard deviation | 4.89017773 |
|---|---|
| Coefficient of variation (CV) | 0.05137010823 |
| Kurtosis | 11.25529773 |
| Mean | 95.19500538 |
| Median Absolute Deviation (MAD) | 2.45 |
| Skewness | -2.478488807 |
| Sum | 38744.36719 |
| Variance | 23.91383823 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 90 | 21.5% |
| 93.75 | 11 | 2.6% |
| 95.83333333 | 7 | 1.7% |
| 95.23857143 | 6 | 1.4% |
| 96.875 | 5 | 1.2% |
| 87.5 | 5 | 1.2% |
| 88.095 | 5 | 1.2% |
| 97.778 | 4 | 1.0% |
| 95.23666667 | 4 | 1.0% |
| 96.666 | 4 | 1.0% |
| Other values (156) | 266 | |
| (Missing) | 11 | 2.6% |
| Value | Count | Frequency (%) |
| 61.666 | 1 | |
| 65 | 1 | |
| 67.06333333 | 1 | |
| 75.258 | 1 | |
| 79.63 | 1 |
| Value | Count | Frequency (%) |
| 100 | 90 | |
| 99.16625 | 2 | 0.5% |
| 98.98 | 2 | 0.5% |
| 98.86375 | 1 | 0.2% |
| 98.76555556 | 2 | 0.5% |
| Distinct | 120 |
|---|---|
| Distinct (%) | 36.0% |
| Missing | 85 |
| Missing (%) | 20.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.91694048 |
|---|---|
| Minimum | 50 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 82.84125 |
| Q1 | 92.855 |
| median | 96.66666667 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 50 |
| Interquartile range (IQR) | 7.145 |
Descriptive statistics
| Standard deviation | 7.137471218 |
|---|---|
| Coefficient of variation (CV) | 0.07519702154 |
| Kurtosis | 17.53841737 |
| Mean | 94.91694048 |
| Median Absolute Deviation (MAD) | 3.333333333 |
| Skewness | -3.472652892 |
| Sum | 31607.34118 |
| Variance | 50.94349538 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 113 | |
| 96.66666667 | 6 | 1.4% |
| 97.22222222 | 5 | 1.2% |
| 97.77777778 | 5 | 1.2% |
| 91.66714286 | 4 | 1.0% |
| 50 | 4 | 1.0% |
| 95 | 4 | 1.0% |
| 96 | 4 | 1.0% |
| 80 | 4 | 1.0% |
| 93.33333333 | 4 | 1.0% |
| Other values (110) | 180 | |
| (Missing) | 85 |
| Value | Count | Frequency (%) |
| 50 | 4 | |
| 73.334 | 1 | 0.2% |
| 77.444 | 2 | |
| 78.03 | 1 | 0.2% |
| 80 | 4 |
| Value | Count | Frequency (%) |
| 100 | 113 | |
| 98.95875 | 1 | 0.2% |
| 98.86375 | 1 | 0.2% |
| 98.76555556 | 1 | 0.2% |
| 98.462 | 1 | 0.2% |
weekbefore
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 3 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.17792771 |
|---|---|
| Minimum | 33.33 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 33.33 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 93.33 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 66.67 |
| Interquartile range (IQR) | 6.67 |
Descriptive statistics
| Standard deviation | 9.941633267 |
|---|---|
| Coefficient of variation (CV) | 0.1044531385 |
| Kurtosis | 8.202619695 |
| Mean | 95.17792771 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.618370844 |
| Sum | 39498.84 |
| Variance | 98.83607202 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 308 | |
| 83.33 | 13 | 3.1% |
| 80 | 13 | 3.1% |
| 75 | 12 | 2.9% |
| 88.89 | 12 | 2.9% |
| 85.71 | 8 | 1.9% |
| 90 | 7 | 1.7% |
| 87.5 | 6 | 1.4% |
| 50 | 5 | 1.2% |
| 66.67 | 5 | 1.2% |
| Other values (11) | 26 | 6.2% |
| Value | Count | Frequency (%) |
| 33.33 | 1 | 0.2% |
| 50 | 5 | |
| 60 | 1 | 0.2% |
| 66.67 | 5 | |
| 71.43 | 3 |
| Value | Count | Frequency (%) |
| 100 | 308 | |
| 94.44 | 1 | 0.2% |
| 93.33 | 4 | 1.0% |
| 92.86 | 1 | 0.2% |
| 92.31 | 3 | 0.7% |
| Distinct | 15 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 106 |
| Missing (%) | 25.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.496794872 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.871299825 |
|---|---|
| Coefficient of variation (CV) | 0.821123323 |
| Kurtosis | 4.893527961 |
| Mean | 3.496794872 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.04125621 |
| Sum | 1091 |
| Variance | 8.244362684 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 81 | |
| 1 | 68 | |
| 3 | 60 | |
| 4 | 32 | 7.7% |
| 5 | 17 | 4.1% |
| 6 | 14 | 3.3% |
| 7 | 12 | 2.9% |
| 9 | 8 | 1.9% |
| 10 | 6 | 1.4% |
| 8 | 5 | 1.2% |
| Other values (5) | 9 | 2.2% |
| (Missing) | 106 |
| Value | Count | Frequency (%) |
| 1 | 68 | |
| 2 | 81 | |
| 3 | 60 | |
| 4 | 32 | 7.7% |
| 5 | 17 | 4.1% |
| Value | Count | Frequency (%) |
| 16 | 4 | |
| 14 | 2 | |
| 13 | 1 | 0.2% |
| 12 | 1 | 0.2% |
| 11 | 1 | 0.2% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 162 |
| Missing (%) | 38.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.375 |
|---|---|
| Minimum | 1 |
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5.25 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.571810496 |
|---|---|
| Coefficient of variation (CV) | 0.6618149457 |
| Kurtosis | 1.422620542 |
| Mean | 2.375 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.31068121 |
| Sum | 608 |
| Variance | 2.470588235 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 99 | |
| 2 | 64 | 15.3% |
| 3 | 40 | 9.6% |
| 4 | 27 | 6.5% |
| 5 | 13 | 3.1% |
| 7 | 6 | 1.4% |
| 6 | 5 | 1.2% |
| 8 | 2 | 0.5% |
| (Missing) | 162 |
| Value | Count | Frequency (%) |
| 1 | 99 | |
| 2 | 64 | |
| 3 | 40 | |
| 4 | 27 | 6.5% |
| 5 | 13 | 3.1% |
| Value | Count | Frequency (%) |
| 8 | 2 | 0.5% |
| 7 | 6 | 1.4% |
| 6 | 5 | 1.2% |
| 5 | 13 | |
| 4 | 27 |
csat
Real number (ℝ≥0)
| Distinct | 219 |
|---|---|
| Distinct (%) | 52.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.86746411 |
|---|---|
| Minimum | 79.26 |
| Maximum | 99.22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 79.26 |
|---|---|
| 5-th percentile | 91.947 |
| Q1 | 93.97 |
| median | 95.085 |
| Q3 | 96.0625 |
| 95-th percentile | 97.16 |
| Maximum | 99.22 |
| Range | 19.96 |
| Interquartile range (IQR) | 2.0925 |
Descriptive statistics
| Standard deviation | 1.833150053 |
|---|---|
| Coefficient of variation (CV) | 0.01932327453 |
| Kurtosis | 12.43087158 |
| Mean | 94.86746411 |
| Median Absolute Deviation (MAD) | 1.095 |
| Skewness | -1.910173617 |
| Sum | 39654.6 |
| Variance | 3.360439117 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 94.41 | 7 | 1.7% |
| 95.78 | 6 | 1.4% |
| 94.78 | 5 | 1.2% |
| 95.47 | 5 | 1.2% |
| 95.52 | 4 | 1.0% |
| 94.64 | 4 | 1.0% |
| 95.85 | 4 | 1.0% |
| 96.01 | 4 | 1.0% |
| 94.08 | 4 | 1.0% |
| 95.58 | 4 | 1.0% |
| Other values (209) | 371 |
| Value | Count | Frequency (%) |
| 79.26 | 1 | |
| 88.75 | 1 | |
| 88.83 | 1 | |
| 89.13 | 1 | |
| 89.61 | 1 |
| Value | Count | Frequency (%) |
| 99.22 | 2 | |
| 98.46 | 1 | |
| 98.14 | 1 | |
| 98 | 2 | |
| 97.99 | 2 |
actualvalue
Real number (ℝ≥0)
| Distinct | 74 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.36593301 |
|---|---|
| Minimum | 50 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.4 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 85.4535 |
| Q1 | 91.3 |
| median | 95.74 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 50 |
| Interquartile range (IQR) | 8.7 |
Descriptive statistics
| Standard deviation | 5.818415338 |
|---|---|
| Coefficient of variation (CV) | 0.06165800678 |
| Kurtosis | 9.862377143 |
| Mean | 94.36593301 |
| Median Absolute Deviation (MAD) | 4.26 |
| Skewness | -2.152489284 |
| Sum | 39444.96 |
| Variance | 33.85395704 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 116 | |
| 90 | 14 | 3.3% |
| 94.44 | 11 | 2.6% |
| 88.89 | 11 | 2.6% |
| 91.67 | 10 | 2.4% |
| 92.31 | 10 | 2.4% |
| 90.91 | 9 | 2.2% |
| 96.67 | 9 | 2.2% |
| 96.88 | 8 | 1.9% |
| 95.65 | 8 | 1.9% |
| Other values (64) | 212 |
| Value | Count | Frequency (%) |
| 50 | 1 | |
| 66.67 | 2 | |
| 75 | 1 | |
| 76.92 | 2 | |
| 77.78 | 2 |
| Value | Count | Frequency (%) |
| 100 | 116 | |
| 98.25 | 3 | 0.7% |
| 98.04 | 2 | 0.5% |
| 97.87 | 4 | 1.0% |
| 97.67 | 1 | 0.2% |
actualvalue_class
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 418 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 418 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 418 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 418 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 222 | |
| 1 | 196 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | Unnamed: 0 | employeeid | Friday | Monday | Saturday | Sunday | Thursday | Tuesday | Wednesday | weekbefore | ncoachingid | total coaching improved | csat | actualvalue | actualvalue_class | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3 | 3 | 26702507 | 91.468000 | 91.880000 | 100.000000 | 91.112000 | NaN | 96.666000 | NaN | 80.0 | NaN | NaN | 95.52 | 90.00 | 0 |
| 1 | 4 | 4 | 26702507 | 91.468000 | 91.880000 | 100.000000 | 91.112000 | NaN | 96.666000 | NaN | 100.0 | NaN | NaN | 95.52 | 90.00 | 0 |
| 2 | 7 | 7 | 26702537 | 100.000000 | 88.527143 | 100.000000 | 95.832857 | NaN | 95.713750 | NaN | 100.0 | 1.0 | 1.0 | 96.63 | 88.89 | 0 |
| 3 | 8 | 8 | 26702537 | 100.000000 | 88.527143 | 100.000000 | 95.832857 | NaN | 95.713750 | NaN | 100.0 | 1.0 | 1.0 | 96.63 | 88.89 | 0 |
| 4 | 10 | 10 | 26702549 | 100.000000 | 98.147778 | 92.857143 | 96.428571 | NaN | 96.875000 | 100.000000 | 100.0 | 1.0 | 1.0 | 97.99 | 80.00 | 0 |
| 5 | 11 | 11 | 26702549 | 100.000000 | 98.147778 | 92.857143 | 96.428571 | NaN | 96.875000 | 100.000000 | 80.0 | 1.0 | 1.0 | 97.99 | 80.00 | 0 |
| 6 | 14 | 14 | 26702594 | 100.000000 | 94.445000 | 89.286667 | NaN | 93.333333 | 95.101429 | 100.000000 | 100.0 | 1.0 | NaN | 96.19 | 100.00 | 1 |
| 7 | 15 | 15 | 26702611 | 95.303333 | 100.000000 | NaN | NaN | 97.281111 | 97.222222 | 98.765556 | 100.0 | 2.0 | NaN | 95.14 | 100.00 | 1 |
| 8 | 16 | 16 | 26702617 | 96.984286 | 91.111111 | 95.221429 | 95.328571 | NaN | 97.601111 | NaN | 100.0 | NaN | NaN | 93.87 | 97.06 | 1 |
| 9 | 17 | 17 | 26702617 | 96.984286 | 91.111111 | 95.221429 | 95.328571 | NaN | 97.601111 | NaN | 100.0 | NaN | NaN | 93.87 | 97.06 | 1 |
Last rows
| df_index | Unnamed: 0 | employeeid | Friday | Monday | Saturday | Sunday | Thursday | Tuesday | Wednesday | weekbefore | ncoachingid | total coaching improved | csat | actualvalue | actualvalue_class | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 408 | 478 | 478 | 26703973 | 93.333333 | 100.000000 | NaN | NaN | 90.000000 | 96.427500 | 78.030000 | 100.00 | NaN | NaN | 96.97 | 100.00 | 1 |
| 409 | 479 | 479 | 26703977 | 90.177500 | 100.000000 | NaN | NaN | 86.000000 | 61.666000 | 92.666000 | 100.00 | NaN | NaN | 79.26 | 92.86 | 1 |
| 410 | 480 | 480 | 26703978 | 100.000000 | 100.000000 | NaN | NaN | 96.666000 | 100.000000 | 73.334000 | 100.00 | NaN | NaN | 96.94 | 88.24 | 0 |
| 411 | 481 | 481 | 26703979 | 93.333333 | 96.427500 | NaN | NaN | 96.427500 | 100.000000 | 100.000000 | 100.00 | NaN | NaN | 97.46 | 100.00 | 1 |
| 412 | 483 | 483 | 26703982 | 93.750000 | 94.443333 | NaN | NaN | 82.666000 | 95.556000 | 91.667500 | 100.00 | NaN | NaN | 97.01 | 93.18 | 0 |
| 413 | 484 | 484 | 26703982 | 93.750000 | 94.443333 | NaN | NaN | 82.666000 | 95.556000 | 91.667500 | 100.00 | NaN | NaN | 97.01 | 93.18 | 0 |
| 414 | 485 | 485 | 26703983 | 83.335000 | 95.832500 | NaN | NaN | 100.000000 | 100.000000 | 100.000000 | 100.00 | NaN | NaN | 91.54 | 88.89 | 1 |
| 415 | 486 | 486 | 35706305 | NaN | 92.000000 | NaN | 93.334 | 79.167500 | 87.500000 | 91.667500 | 100.00 | 5.0 | 4.0 | 95.95 | 87.50 | 0 |
| 416 | 487 | 487 | 35706317 | 81.770000 | NaN | 81.99375 | NaN | 87.213333 | 86.837778 | 86.648889 | 33.33 | 16.0 | 4.0 | 96.68 | 88.46 | 1 |
| 417 | 488 | 488 | 35706317 | 81.770000 | NaN | 81.99375 | NaN | 87.213333 | 86.837778 | 86.648889 | 50.00 | 16.0 | 4.0 | 96.68 | 88.46 | 1 |